Top Deals: Henry

SELECT distinct b.style_id
    FROM tb_term_sale_entries b with (nolock) LEFT JOIN tb_term_sales a with (nolock) ON (a.term_sale_id=b.term_sale_id)
    WHERE b.start_date<= '2024-05-20 14:00:00' AND b.end_date >= '2024-05-20 14:00:00' AND b.store_id=10

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock)

SELECT a.styles_web_taxonomy_id,max(a.style_id) as style_id,max(a.style) as style,max(a.web_style) as web_style,max(a.description) as web_desc,max(a.web_desc) as web_description,max(a.web_long_desc) as web_long_desc,max(a.picture_id) as picture_id,max(a.sort_position) as prod_sort_position,max(a.dept) as dept,max(a.typ) as typ,max(a.subtyp_1) as subtyp_1,max(a.subtyp_2) as subtyp_2,max(a.subtyp_3) as subtyp_3,max(a.category_style) as category_style,max(a.web_url) as web_url,max(a.sort_position) as sort_position,max(a.web_taxonomy_id) as web_taxonomy_id,max(a.brand) as brand,max(a.date_entered) as date_entered,max(a.non_invt) as non_invt,max(a.overnight_required) as overnight_required,max(a.is_firearm) as is_firearm,max(a.of1) as of1,max(a.of2) as of2,max(a.of3) as of3,max(a.of4) as of4,max(a.of5) as of5,max(a.of6) as of6,max(a.of7) as of7,max(a.of8) as of8,max(a.of9) as of9,max(a.of10) as of10,max(a.of11) as of11,max(a.of12) as of12,max(a.of13) as of13,max(a.of14) as of14,max(a.of15) as of15,max(a.of16) as of16,max(a.of17) as of17,max(a.of18) as of18,max(a.of19) as of19,max(a.of20) as of20
,min(c.price) as min_price,min(c.store_price) as store_price,max(c.sugg_price) as max_price,min(c.wholesale_price) as vipprice,max(c.qoh) as qoh,max(c.qc) as qc,max(c.qs) as qs,sum(qoh + qc) as available,sum(c.qs - c.qc) as sold,max(c.sugg_price) AS max_sugg_price,avg(c.price / qq.of9) as round
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
 
 WHERE a.style_id > 0 and (a.of20='SPORTS' or a.of20='BOTH' or a.of20 = 'SPORTSOUTDOORS') and a.picture_id > 0
and qq.web_product='Y' and qq.status_finish <> 'Y' and c.store_id=10 
	
	and (a.style_id in (4636,4644,6319,12712,12715,12719,12835,12846,19033,19061,19084,19158,19180,19181,19300,23377,23378,23379,23380,23381,23382,23383,23384,23385,23388,23389,23390,23391,23410,23539,23552,24654,24660,24663,24690,24701,24704,24727,24736,24747,24749,26274,28391,34461,35058,35066,35067,35068,35069,35071,35084,35086,35087,35088,35089,35090,35092,35093,35095,35096,35107,35110,35111,35114,35118,35119,35123,35126,35129,35150,35151,36610,39334,39351,42205,43025,44617,44618,44629,44652,44653,44655,44656,44665,44666,44677,44703,44705,44706,44707,44708,44753,44754,44756,44757,44758,44759,44760,44761,44766,44767,44768,44774,46430,46450,48786,48792,48794,48798,48802,48818,48820,48837,48860,48866,48875,48880,48923,48924,50221,50329,50364,50446,50447,53934,53952,53992,53993,58441,61119,61129,61293,61294,61404,61808,61810,63789,64137,64138,67023,67732,69632,69675,70172,70499,70698,71036,72107,72333,72688,72706,72809,73371,73464,74223,74911,74926,75051,75180,75310,75311,75323,77853,79544,79655,80044,84992,85328,85743,86559,86578,86668,87024,87653,90898,91669,93752,97510,99082,99083,100867,104005,104468,105569,107584,108064,109828,110828,111160,111545,111733,113186,113580,113681,114140,114665,115349,115749,116856,117262,118073,118076,118885,120925,120940,121157,121165,121166,121650,121796,121981,122022,122149,122204,122241,122681,124548,125355,125435,126066,126525,127973,128633,132756,133815,133913,133914,134428,134634,136382,137515,137599,137687,138588,138589,141248,141249,143335,145597,148056,148591,148856,148857,150079,150141,150675,150679,150680,150696,151725,152488,152548,152553,152953,153292,156357,158338,158504,159077,159428,161335,161336,161338,161344,161347,161348,161350,161352,161439,161632,161638,161765,161981,162081,162540,162546,162868,163627,163822,163924,164607,164627,164654,165038,165178,168188,168302,168322,168578,168678,168679,168680,168752,168753,168754,168795,168818,169080,169095,169163,169274,169407,169801,169803,169804,169806,169808,169810,169812,169813,169814,169815,170100,170101,170574,172060,172483,172485,172725,172949,172950,173263,173297,173298,175615,179485,179675,179916,179917,179936,180017,181439,181500,181653,181921,182210,182503,183620,183757,183795,185620,188448,189101,189102,189105,189110,189113,189122,189123,189124,189129,189189,189190,189753,189765,189773,189779,189786,190015,191231,191503,192093,192948,193312,193318,193324,193325,193329,193335,193336,193472,193529,193604,193659,193766,195498,195559,195598,195599,195880,195975,197836,198038,198207,198208,198319,198450,199005,199083,199109,199530,199758,199850,200328,200558,201601,201633,201636,201784,201824,202158,202302,202491,202502,202503,202506,202508,202512,202517,202518,202519,202523,202525,202666,202670,202671,202719,202913,203043,203111,203112,203115,203243,203613,203838,203889,203891,203892,203893,203895,203897,203899,203908,203911,203917,204088,204208,204210,204264,204462,204584,204702,204705,205184,205227,205230,205560,205613,205614,205649,205655,206106,206320,206321,207322,207954,208201,208444,208477,208654,208686,208727,209448,209579,209580,209991,210101,210105,210166,210167,210201,210309,210660,210661,210662,210663,210664,210665,210677,210681,211004,211300,211780,212823,212824,212931,213301,213442,213783,213797,213841,213845,213846,213848,213849,214265,214524,214587,214886,215017,215085,215086,215088,215133,215162,215163,215164,215181,215222,215223,215655,215689,215789,215810,215944,215946,215985,216268,216269,216287,216289,216290,216298,216569,216692,216705,216854,216956,216961,216966,216969,217040,217041,217165,217170,217177,217249,217293,217302,217304,217322,217370,217383,217903,218049,218055,218419,218421,218441,218442,218490,218558,219605,219774,219779,219799,219800,219801,219802,219803,219804,220136,220569,220615,220749,221125,221135,221152,221154,221156,221997,221999,222329,222481,222658,222768,223106,223129,223131,224185,224187,224202,225241,225336,225904,225909,225923,225924,225961,227192,227194,227286,227302,227466,227470,227471,227472,227474,227544,227801,228133,228141,228150,228207,228579,231773,231799,231800,231801,232185,232631,242351,244957,245075,245411,245412,245441,245607,245608,245811,245844,245845,246438,246555,246700,246779,246937,246938,246940,247067,247095,247167,247168,247169,247191,247210,247218,247219,247220,247221,247247,247441,247468,247475,247476,247510,247521,247760,247919,247929,247933,247937,247938,247941,247942,247944,247947,247950,247983,248088,248733,248735,248846,248908,248960,248992,248994,249000,249045,249177,249451,249454,249478,249479,249485,249488,249495,249844,249845,249873,249897,249899,249953,250062,250092,250093,250096,250133,250170,250171,250461,250681,250692,250777,250778,250779,250950,251024,251139,251295,251457,251459,251461,251462,251463,251569,251570,251572,251574,251675,251722,251757,251902,251953,252148,252227,252253,252295,252391,252546,253021,253028,253322,253369,253425,253446,253465,253519,253520,253535,253735,253738,253743,253746,253832,254141,254142,254144,254415,254516,254519,255170,255483,255638,255987,256128,256285,256418,256421,256763,256887,256943,257010,257118,257124,257126,257127,257194,257195,257199,257201,257207,257212,257214,257226,257263,257275,257280,257281,257288,257296,260372,260552,260553,260554,260555,260561,260592,260595,260606,260614,260927,260938,260939,260940,261273,261337,261340,261613,261678,261679,261713,261881,261882,261885,261945,261947,261975,262010,262011,262111,262112,262115,262117,262118,262119,262123,262139,262141,262151,262155,262156,262157,262158,262168,262183,262299,262487,262538,262570,262574,262593,262604,262660,262670,262689,262735,262879,262882,262883,262938,262947,262948,262949,263040,263196,263257,263281,263381,263396,263397,263398,263620,263637,263798,264013,264019,264030,264088,264110,264111,264563,264625,264627,264633,264647,264820,264833,264846,266054,266122,266123,266407,266573,266744,266801,266834,266910,266940,266941,266942,266979,267031,267126,267159,267183,267937,268172,268182,268703,268728,268733,268770,268873,268874,269022,269087,269088,269090,269091,269092,269093,269094,269095,269096,269303,269388,269389,269444,269471,269936,270027,270031,270141,270246,270321,270322,270325,271005,271054,271453,271454,271455,271456,271643,271776,272181,272666,272735,273250,273255,273263,273401,273432,273438,273465,273466,273499,273500,273510,273512,273595,273596,274086,274107,274109,274371,274504,274642,274643,275679,275749,275753,275848,275983,275985,275989,276181,276182,276663,276743,276754,276787,276790,276808,276811,276817,276819,276825,276846,276847,276852,276913,276916,276923,276925,276927,276932,276947,276949,276958,276961,276969,277028,277029,277031,277032,277071,277073,277078,277287,277331,277379,277581,277988,277989,277990,277991,277992,278069,278084,278147,278243,278245,278268,278322,278323,278324,278327,278473,278580,278701,278706,278721,278723,278730,279060,279115,279152,279551,279648,279779,279925,279975,280276,280347,280403,280517,280518,280594,280765,281011,281026,281031,281338,281341,281459,281494,281495,281497,281498,281520,281522,281527,281659,281856,282030,282383,282386,282719,282860,282867,282911,282975,282977,282978,282994,282995,283200,283412,283422,283423,283424,283425,283443,283625,283818,283824,283892,283968,283976,284111,284454,284688,284750,284941,284945,284946,285285,285309,285353,285801,285851,286272,286274,286665,286666,286676,286762,286763,286887,286888,287025,287056,287063,287120,287186,287191,287192,287194,287349,287350,287369,287422,287424,287427,287491,287492,287494,287506,287516,287517,287518,287522,287524,287526,287527,287539,287541,287543,287546,287555,287657,287942,287961,288090,288383,288434,288436,288437,288490,288589,288675,288882,288884,288905,288910,288914,288916,288948,288979,289163,289165,289187,289191,289233,289240,289241,289547,289548,289578,289581,289623,289798,289818,289850,289855,289944,289947,289964,289965,289999,290008,290009,290015,290108,290123,290180,290404,290405,290406,290408,290410,290412,290414,290417,290418,290419,290420,290421,290422,290423,290424,290425,290426,290428,290430,290431,290468,290893,290906,290956,291160,291176,291178,291180,291252,291256,291257,291261,291269,291312,291324,291366,291471,291503,291505,291945,291987,291988,291989,291990,291991,292002,292012,292213,292214,292215,292247,292278,292282,292346,292353,292373,292469,292471,292475,292476,292477,292479,292481,292495,292652,292659,292661,292751,292757,292769,292774,292775,292822,292885,292886,292887,292965,293138,293192,293221,293282,293293,293414,293418,293461,293486,293487,293490,293567,293568,294596,294625,294925,295000,295001,295002,295087,295109,296108,296130,296153,296224,296316,296394,296409,296429,296572,296611,296719,296789,296790,296792,296797,296799,296889,296918,296919,296922,296923,296926,296932,296934,297063,297064,297178,297181,297182,297183,297184,297185,297219,297220,297221,297229,297230,297234,297235,297253,297285,297286,297288,297290,297291,297292,297294,297298,297299,297511,297512,297513,297514,297515,297522,297523,297525,297527,297528,297530,297533,297541,297543,297544,297561,297588,297715,297722,297723,297724,297725,297727,297728,297729,297730,297731,297732,297733,297734,297735,297847,297941,298195,298215,298224,298288,298314,298405,298407,298566,298583,298584,299051,299128,299143,299194,299336,299372,299397,299439,300496,300519,300520,300547,300550,300560,300562,300564,300567,300570,300579,300580,300583,300584,300598,300599,300646,300707,300708,300710,300712,300713,300725,300738,300881,300883,300891,300913,300928,300990,301083,301107,301109,301166,301200,301436,301454,301457,301483,301485,301486,301487,301488,301489,301490,301491,301499,301500,301579,301610,301735,301736,301785,301820,301821,301998,302046,302047,302061,302122,302221,302222,302479,302480,302497,302518,302524,302558,302569,302572,302573,302574,302575,302577,302585,302657,302659,302756,303049,303065,303111,303112,303154,303262,303288,303289,303298,303300,303330,303364,303365,303367,303369,303447,303448,303449,303450,303511,303513,303540,303569,303607,303609,303610,303611,303613,303618,303678,303688,303792,303927,303928,303952,303953,303961,304035,304113,304116,304118,304120,304302,304303,304304,304305,304307,304309,304310,304312,304313,304314,304317,304319,304320,304323,304324,304549,304633,304689,304690,304691,304694,304695,304696,304698,304699,304701,304703,304720,304799,304800,304801,304802,304803,304804,304805,304878,304880,304887,304891,304894,304902,304915,304916,304929,305036,305037,305039,305040,305044,305049,305051,305055,305059,305100,305458,305467,305496,305497,305498,305499,305502,305503,305504,305505,305506,305507,305510,305511,305538,305544,305545,305546,305547,305549,305576,305578,305579,305585,305598,305647,306678,306679,306881,306973,307191,307193,307194,307357,307449,307521,307659,307673,307676,307678,307679,307685,307689,307692,307695,307698,307702,307703,307722,307727,307731,307738,307740,307741,307748,307749,307750,307751,307755,307758,307777,307781,307784,307787,307797,307798,307804,307806,307810,307862,307889,307890,307896,307906,307908,308066,308138,309353,309356,309357,309359,309360,309482,309493,309539,309567,309571,309572,309574,309575,309576,309591,309592,309603,309610,309614,309618,309650,309652,309682,309697,309732,309733,309734,309837,309879,309880,309946,310121,310134,310153,310154,310155,310156,310398,310762,310763,310788,310791) or a.style_id in (228179,175601,284594,296795,206090,217506,280519,217505,203445,113771,284595,284592,75326,109120,203445,284593,204900,217500))

	
	 and a.brand='HENRY REPEATING ARMS'
	
	
	group by a.styles_web_taxonomy_id

select
		distinct
		(style_id) as style_id
		, max(picture_id)
			,	min(min_price) as min_price
			,	max(max_price) as max_price
			,	min(vipprice) as vipprice
			,	max(web_style) as web_style
            ,	max(style) as style
			,	max(web_desc) as web_desc
            ,	max(web_description) as web_description
			,	max(picture_id) as picture_id
            ,	max(web_long_desc) as web_long_desc
			,   max(dept) as dept
            ,   max(qoh) as qoh
            ,	max(qc) as qc
            ,	max(qs) as qs
            ,	max(of18) as of18
            ,	max(of12) as of12
    		,	max(of10) as of10
    		,	max(of9) as of9
    		,	max(of8) as of8
			,	max(of7) as of7
    		,	max(of6) as of6
    		,	max(of5) as of5
            ,	max(of4) as of4
    		,	max(of3) as of3
            ,	max(of2) as of2
            ,	max(of1) as of1
			,	max(available) as available
            ,	max(available) as sold
			,   max(typ) as typ
            ,	max(round) as round
            ,	max(non_invt) as non_invt
			,	max(overnight_required) as overnight_required
			,   max(subtyp_1) as subtyp_1
			,   max(subtyp_2) as subtyp_2
			,   max(subtyp_3) as subtyp_3
			,   max(category_style) as category_style
		     ,   max(sort_position) as sort_position
		     ,max(brand) as brand
	,	MAX(max_sugg_price) AS max_sugg_price
    

		from grandgetproductsHENRYREPEATINGARMS
		where
		 style_id is not null
           
            
				and brand='HENRY REPEATING ARMS'
			

group by Style_id order by

 available  desc

select * from grandgetproductsHENRYREPEATINGARMS
		where
		 picture_id is not null
            
			
				and brand='HENRY REPEATING ARMS'
			


order by

min_price

select distinct (dept) as dept from getproducts1
			where dept not in (?,?,?,?,?,?,?,?,?,?,?)
			and brand='HENRY REPEATING ARMS' group by dept

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a with (nolock) left join tb_styles b with (nolock) on (a.category_style=b.style) where dept='Firearms' and typ='EMPTY' and site = 'sportsman'

select distinct typ from getproducts1 where dept='Firearms' and brand='HENRY REPEATING ARMS' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a with (nolock) left join tb_styles b with (nolock) on (a.category_style=b.style) where dept='Firearms' and typ='Lever Action' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a with (nolock) left join tb_styles b with (nolock) on (a.category_style=b.style) where dept='Firearms' and typ='Pump Action Rifles' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a with (nolock) left join tb_styles b with (nolock) on (a.category_style=b.style) where dept='Firearms' and typ='Semi-Auto Rifles' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a with (nolock) left join tb_styles b with (nolock) on (a.category_style=b.style) where dept='Firearms' and typ='Shotguns' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a with (nolock) left join tb_styles b with (nolock) on (a.category_style=b.style) where dept='Firearms' and typ='Single-Shot Rifles' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url from tb_web_taxonomy with (nolock) where dept='' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 152953 and e.store_id = 10 
			group by a.style_id, e.qc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:24' and
end_date >= 'May 20, 2024 14:55:24'
and store_id=10 and style_id=152953

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 152953 
and (a.start_date<= 'May 20, 2024 14:55:24' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:24'
order by a.promo_id desc

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 224202 and e.store_id = 10 
			group by a.style_id, e.qc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:24' and
end_date >= 'May 20, 2024 14:55:24'
and store_id=10 and style_id=224202

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 224202 
and (a.start_date<= 'May 20, 2024 14:55:24' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:24'
order by a.promo_id desc

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 249177 and e.store_id = 10 
			group by a.style_id, e.qc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:24' and
end_date >= 'May 20, 2024 14:55:24'
and store_id=10 and style_id=249177

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 249177 
and (a.start_date<= 'May 20, 2024 14:55:24' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:24'
order by a.promo_id desc

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 257126 and e.store_id = 10 
			group by a.style_id, e.qc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:24' and
end_date >= 'May 20, 2024 14:55:24'
and store_id=10 and style_id=257126

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 257126 
and (a.start_date<= 'May 20, 2024 14:55:24' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:24'
order by a.promo_id desc

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 257207 and e.store_id = 10 
			group by a.style_id, e.qc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:24' and
end_date >= 'May 20, 2024 14:55:24'
and store_id=10 and style_id=257207

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 257207 
and (a.start_date<= 'May 20, 2024 14:55:24' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:24'
order by a.promo_id desc

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 257214 and e.store_id = 10 
			group by a.style_id, e.qc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:24' and
end_date >= 'May 20, 2024 14:55:24'
and store_id=10 and style_id=257214

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 257214 
and (a.start_date<= 'May 20, 2024 14:55:24' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:24'
order by a.promo_id desc

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 262570 and e.store_id = 10 
			group by a.style_id, e.qc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:24' and
end_date >= 'May 20, 2024 14:55:24'
and store_id=10 and style_id=262570

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 262570 
and (a.start_date<= 'May 20, 2024 14:55:24' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:24'
order by a.promo_id desc

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 291991 and e.store_id = 10 
			group by a.style_id, e.qc

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:24' and
end_date >= 'May 20, 2024 14:55:24'
and store_id=10 and style_id=291991

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 291991 
and (a.start_date<= 'May 20, 2024 14:55:24' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:24'
order by a.promo_id desc

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\inetpub\images\
logdir=E:\inetpub\logs
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\black-friday.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=CFTOKEN=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF; CFGLOBALS=urltoken%3DCFID%23%3D8512%26CFTOKEN%23%3Dee4e16a37a9175ca%2DE994AB14%2D9E00%2D26DC%2D57DC0CDC4B6F2AFF%23lastvisit%3D%7Bts%20%272024%2D05%2D20%2014%3A55%3A24%27%7D%23hitcount%3D13%23timecreated%3D%7Bts%20%272024%2D05%2D20%2014%3A55%3A18%27%7D%23cftoken%3Dee4e16a37a9175ca%2DE994AB14%2D9E00%2D26DC%2D57DC0CDC4B6F2AFF%23cfid%3D8512%23; CFID=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-8512; CT_U=91; PRD_U=290651%2C91; LAST_NAME=; USERNAME=; CUSTOMER_ID=; EMAIL=; PASSWORD=; FIRST_NAME=
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/black-friday.cfm/CurrentPage/4/brand/HENRY%20REPEATING%20ARMS
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/CurrentPage/4/brand/HENRY REPEATING ARMS
PATH_TRANSLATED=E:\inetpub\wwwroot\black-friday.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/black-friday.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=8512
cftoken=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
hitcount=13
lastvisit={ts '2024-05-20 14:55:24'}
timecreated={ts '2024-05-20 14:55:18'}
urltoken=CFID=8512&CFTOKEN=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF

Cookie Variables:
CFGLOBALS=urltoken=CFID#=8512&CFTOKEN#=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF#lastvisit={ts '2024-05-20 14:55:24'}#hitcount=13#timecreated={ts '2024-05-20 14:55:18'}#cftoken=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF#cfid=8512#
CFID=8512
CFTOKEN=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
CT_U=91
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PRD_U=290651,91
USERNAME=

Form Fields:
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=8512
cftoken=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
cs=/black-friday.cfm/CurrentPage/4/brand/HENRY REPEATING ARMS
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_8512_ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
strarray=Array (0)
urltoken=CFID=8512&CFTOKEN=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF

URL Parameters:
CLEARANCE=
CurrentPage=4
DEPT=
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
ORDER_BY=
PAGETYPE=
PRODTYPE=none
RETURN_TO_PAGE=null
SALE=
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WEB_TAXONOMY_ID=HENRYREPEATINGARMS
WHATSNEW=
brand=HENRY REPEATING ARMS